package com.dcyao.musicserve.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dcyao.musicserve.domain.StaffList;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author admin
* @description 针对表【staff_list(乐谱分类表)】的数据库操作Mapper
* @Entity com.xs.domain.StaffList
*/
@Mapper
public interface StaffListMapper extends BaseMapper<StaffList> {

    /**
     * 查询乐谱集总数
     * @return
     */
    @Select("SELECT COUNT(id) FROM staff_list")
    int staffListCount();

    /**
     * 查询乐谱集所有风格
     * @return
     */
    @Select("SELECT DISTINCT style FROM staff_list")
    List<StaffList> StaffStyle();


}
